package com.zhhh.repository;

import java.util.List;

import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;

import com.zhhh.domain.BPosition;

public interface PositionRepository extends CrudRepository<BPosition, Integer>{

	//BPosition findById(Integer pid);

	@Query("select s from BPosition s where s.OSysCode like CONCAT(:osysCode,'%')")
	List<BPosition> findByUserList(String osysCode);

	@Query("select s from BPosition s where s.OSysCode = -1")
	List<BPosition> queryNotDeptUserAll();

}
